TG: sql_for_qa/64

SQL для тестировщика

Какой из следующих SQL запросов вернет топ-5 самых просматриваемых постов из таблицы posts, отсортированных по количеству просмотров в порядке убывания?

Anonymous Quiz

SELECT * FROM posts ORDER BY views DESC LIMIT 5;

SELECT TOP 5 * FROM posts ORDER BY views DESC;

SELECT * FROM posts WHERE ROWNUM <= 5 ORDER BY views DESC;

SELECT * FROM posts WHERE views >= 5 ORDER BY views DESC LIMIT 5;

641 answered

www.tg-me.com/vn/SQL для тестировщика/com.sql_for_qa/64

2.6K viewsMar 17, 2023 at 11:02

tg-me.com/sql_for_qa/64

Create: 2023-03-17
Last Update: 2025-07-02 19:51:53

BY SQL для тестировщика

Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/sql_for_qa/64

SQL для тестировщика Telegram | DID YOU KNOW?

Telegram today rolling out an update which brings with it several new features.The update also adds interactive emoji. When you send one of the select animated emoji in chat, you can now tap on it to initiate a full screen animation. The update also adds interactive emoji. When you send one of the select animated emoji in chat, you can now tap on it to initiate a full screen animation. This is then visible to you or anyone else who's also present in chat at the moment. The animations are also accompanied by vibrations. This is then visible to you or anyone else who's also present in chat at the moment. The animations are also accompanied by vibrations.